.nsf data extraction

Notes/Domino 8 Forum

Subject: .nsf data extraction

Feedback Type: Question

Product Area: Designer Client

Technical Area: Application development

Platform: Not Applicable

Release: 8.0.2

Reproducible: Always

I have no idea where to put this question.. So I will start here.

The issue.

I have a finished goods .nsf file that I have to extract data from. So I installed designer and the notes client on my workstation. I then copied over my .nsf files into the Data folder. Double clicked on my nsf file and it opened up in Notes. So far so good. *Note we do not have a running notes server this was shut down and I cannot bring it back (company was sold off). Now, I have read online that you can go to the file->export from a view and save off the data as a CSV file inside of the notes client (I tried this and it worked). However, the view that I would need to extract all the data isn't a view listed. So from there I double click one of my items and it came up in the data form... I went to export that as a csv file but that wasn't an option.. I exported it to a text file, but that format does me no good.. The data looked like an export of the form. Now I thought I could format with a vb.net app or macro. However this form uses tabs in it.. when you export that it makes a huge mess to parse. So next, I thought I would try and make the view and display everything that I need.

From here I opened up Domino Designer and opened the FG in the applications explorer. I see all the forms etc. So far so good. So I went into my designer and into the views, tried to create a new view (which seemed to just copy other views at first.. then I saw the new blank view). I tried the new blank view and I can not figure out how to connect to anything to pick my columns. So I tried to create a new view based off a old one. Did the insert column and once again I don't see any fields to hook to. So at this point I'm stuck. I read online that maybe SQLNotes would work. So I downloaded SQLNotes and I keep getting errors on this application when I try to make a user DSN. So another wall. I would just say I would hand key the data but when I do my data extract I have over 1000 items and when I look at the details of each item in the form in my text editor it tells me I have over 315 lines of formatted data. That's a ton of hand keying. Anyone have any suggestions? If this is the wrong place please point me to a place to post this. I'm not finding a ton of resources online to do this type of stuff.

Feedback number WEBB9CL5HX created by ~Sean Zekwelitflar on 10/18/2013